Found 3 results
In this tutorial called create MySQL slave by cloning we’ll try to guide you through a very detailed but in the same time simple process to create a MySQL slave, also known as MySQL replica, by using a fresh backup taken from an existing MySQL server referred here as MySQL master server. Assuming that our master database is 11TB large we’ll have to copy its data content from US, where the master server is located to another server located in a UK data centre, not quite an easy task with this amount of data or without using a costly commercial […]
Category: MySQL | Published: 06/07/2018 | Updated: 05/11/2018MySQL GTID replication error can happen unexpectedly for various reasons and as often as the classic master slave, circular or multi-master replication but in this short tutorial we will learn, step by step, how to skip MySQL GTID transaction error in order to keep in sync our MySQL slave server. Before we begin we need to say that all below steps were tested in a master-slave setup using MySQL 5.6 and MySQL 5.7, we think that this MySQL skipping transaction method detailed below can be easily applied even for newer MySQL versions like 8+. Please note that all below operations […]
Category: MySQL | Published: 28/06/2018 | Updated: 05/11/2018How to create partitions larger than 2TB in Linux
It’s well known that is impossible to create partitions larger than 2TB in Linux using the default utility fdisk that comes with most of Linux distros, at least for now. In this short tutorial we’ll learn how to create larger than 2TB partitions using parted utility instead of fdisk on CentOS Linux. Assuming that we have to add three new disks to a new fictive server called mydbhost that will be used for a MySQL service for example, being master, slave, standalone it doesn’t matter, all that we care is the partitioning bit. Installing parted utility We can start our […]
Category: General | Published: 04/06/2018 | Updated: 05/11/2018